create external table jms_dm.dm_all_transfer_count_bak_dt (

   date_time string comment '签收日期' ,
   taking_code string comment '揽收网点',
   taking_name string comment '揽收网点' ,
   taking_agent_code string comment '代理区编码',
   taking_agent_name string comment '代理区名称,',
   taking_provider_id string comment '省份id',
   taking_provider_desc string comment '省份',
   taking_city_id string comment '城市id',
   taking_city_desc string comment '城市',
   first_center_network_code string comment '始发中心',
   first_center_network_name string comment '始发中心' ,
   front_number bigint comment '件量',
   front_plan_zz   bigint comment '规划中转次数',
   front_actual_zz   bigint comment '实际中转次数',
   front_agent_in bigint comment '代理区内中转次数',
   front_agent_out bigint comment '代理区外中转次数',
   front_reback bigint comment '退件件量',
   front_reback_zz bigint comment '退件中转次数',
   front_rational bigint comment '不合理件量',
   front_rational_zz bigint comment '不合理中转次数',
   front_proble bigint comment '问题件件量',
   front_proble_zz bigint comment '问题件中转次数',
   front_is_wrong bigint comment '网点错发件件量',
   front_is_wrong_zz bigint comment '网点错发件中转次数',
   front_bak_route bigint comment '备用路由件量',
   front_bak_route_zz bigint comment '备用路由中转次数'
) COMMENT '全程中转次数汇总表_网点'
PARTITIONED BY (dt varchar(200) COMMENT '签收日期')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_all_transfer_count_bak_dt'
TBLPROPERTIES (
'discover.partitions'='false',
'parquet.column.index.access'='true'
);
